Dashboard 02 - Create a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller 18
Next, we will create a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller
Step 1 - Download Scroller Visual
In Power BI Desktop, click on the page, RaleighPoliceIncidents-District
If you don't see the Scroller Visualizations under Visualizations, follow these steps to add it.
Under Visualizations, click on the Ellipsis (...) -> Import a Visual from a file -> browse to the extracted folder -> template and select the visualization, Scroller.2.0.3.0.pbiviz
When it is installed successfully, you will now see the Scroller visualizations icon under Visualizations.
Step 2 - Create a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller
Visualizations
Click the Scroller icon
Fields
Select the following:
A_KeyMeasures -> .Total_Violent_Crimes - Under Visualizations, drag & drop it in the Measure Absolute section.
A_KeyMeasures -> .YOY_Violent_CrimeRate% - Under Visualizations, drag & drop it in the Measure Deviation section.Raleigh_Police_Incidents_NIBRS -> District - Under Visualizations, drag & drop it in the Category section
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Violent_Crimes = Total Violent Crimes
District = District Name
Format tab
Under Format -> General: X Position = 360 , Y Position = 947 , Width = 1039 , Height = 53
Under Format -> Scroller -> Set Status Indicator to ON -> Font Size = 18 , Scroll Speed = 1 , TextColor = FFFFFF , Background Color = 094780 , Update Interval = 50
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Filters
None